package com.class05.mapper;

import com.class05.pojo.Employee;

import java.util.List;
import java.util.Map;

public interface EmployeeMapper {
    Employee getEmployeeById(Integer id);


    int getEmployeeCount();


//    查询比平均薪资高的员工姓名和薪资
    Map<String, Object> getEmployeeByAvgSalary();



//    查询所有员工id
    List<Integer> getAllEmployeeId();

//    插入一条员工数据
    int insertEmployee(Employee employee);


    int deleteEmployeeById(Integer id);
}
